package com.sun.temp.mapper.mapper3;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sun.temp.bean.Qakansa;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
@DS("db3")
public interface QakansaDao extends BaseMapper<Qakansa> {
    // 查询批号、等级，进行排序功能
    List<Qakansa> getQAKANSA();
//    Qakansa getByBatch(String lot_no);
    List<Qakansa> getByBatch(String lot_no);

    Qakansa getByBatchAndItemID(String lot_no,String itemId);
}
